CREATE TABLE "iws_inventory_task_record"
(
    "id"             VARCHAR(50) PRIMARY KEY,
    "task_id"        VARCHAR(50) NULL DEFAULT NULL,
    "task_status"    INT         NULL DEFAULT NULL,
    "floor"          VARCHAR(50) NULL DEFAULT NULL,
    "create_name"    VARCHAR(50) NULL DEFAULT NULL,
    "create_date"    DATETIME    NULL DEFAULT NULL,
    "complete_date"  DATETIME    NULL DEFAULT NULL,
    "inventory_type" VARCHAR(50) NULL DEFAULT NULL,
    "item_bar_code"  VARCHAR(50) NULL DEFAULT NULL,
    "material_code"  VARCHAR(50) NULL DEFAULT NULL,
    "material_name"  VARCHAR(50) NULL DEFAULT NULL,
    "entry_time"     DATETIME    NULL DEFAULT NULL,
    "container_code" VARCHAR(50) NULL DEFAULT NULL,
    "inventory_quantity" FLOAT       NULL DEFAULT NULL,
    "start_name"    VARCHAR(50) NULL DEFAULT NULL,
    "start_date"     DATETIME    NULL DEFAULT NULL,
);
exec sp_addextendedproperty 'MS_Description', N'任务单号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'id'
go
exec sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'task_status'
go
exec sp_addextendedproperty 'MS_Description', N'仓库', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'floor'
go
exec sp_addextendedproperty 'MS_Description', N'建单账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'create_name'
go
exec sp_addextendedproperty 'MS_Description', N'建单时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'create_date'
go
exec sp_addextendedproperty 'MS_Description', N'完成时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'complete_date'
go
exec sp_addextendedproperty 'MS_Description', N'盘点类型（全盘，抽盘，动碰盘）', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'inventory_type'
go
exec sp_addextendedproperty 'MS_Description', N'物料条码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'item_bar_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料的编号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'material_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料的名称', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'material_name'
go
exec sp_addextendedproperty 'MS_Description', N'入厂时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'entry_time'
go
exec sp_addextendedproperty 'MS_Description', N'载具码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'container_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料数量', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'inventory_quantity'
go
exec sp_addextendedproperty 'MS_Description', N'盘点账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'start_name'
go
exec sp_addextendedproperty 'MS_Description', N'开始时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task_record', 'COLUMN', 'start_date'
go

